﻿CREATE VIEW [dbo].[vwBillingsByEngineer]
AS
SELECT     e.EntryDate, e.Duration, u.FullName, p.Name AS Project, c.Name AS Category, e.Description
FROM         dbo.EntryLog e INNER JOIN
                      dbo.Users u ON e.UserID = u.UserID INNER JOIN
                      dbo.Projects p ON e.ProjectID = p.ProjectID INNER JOIN
                      dbo.Categories c ON c.CategoryID = e.CategoryID;

